On Combining Business Process Integration and ETL Technologies
نویسندگان
چکیده
In this paper we contrast two important information technologies in the realm of Business Integration: Process Integration and Extract-Transform-Load (ETL) Technology. After a short characterization and description of either technology, we argue for a technology crossover that results in a synergy of the available technologies, and thus realizes a more complete and superior approach. A technological study as well as show cases will provide insight into the approach proposed.
منابع مشابه
On the Use of Dimension Properties in Heterogeneous Data Warehouse Integration
A new trend in Business Intelligence is the process of combining information from two or more different and heterogeneous Data Warehouses. Existing solutions rely mostly on the Extract-Transform-Load (ETL) approach, a costly and laborious process. The process of Data Warehouse integration can be greatly simplified by developing methods to semi-automatically discover semantic mappings among attr...
متن کاملContainer-Managed ETL Applications for Integrating Data in Near Real-Time
As the analytical capabilities and applications of e-business systems expand, providing real-time access to critical business performance indicators to improve the speed and effectiveness of business operations has become crucial. The monitoring of business activities requires focused, yet incremental enterprise application integration (EAI) efforts and balancing information requirements in rea...
متن کاملEnterprise Resource Planning and Business Intelligence: The Importance of Integration
The advancement of information and communications technologies (ICT) has significantly intensified market competition the world over. One of the most widespread solutions is the use of enterprise resource planning systems that has proved to support the integration and automation of the processes, the improvement of the performance, and the reduction of costs. ERP involves the planning and manag...
متن کاملIntegrating Data in near Real-time
As the analytical capabilities and applications of e-business systems expand, providing real-time access to critical business performance indicators to improve the speed and effectiveness of business operations has become crucial. The monitoring of business activities requires focused, yet incremental enterprise application integration (EAI) efforts and balancing information requirements in rea...
متن کاملMAIME: A Maintenance Manager for ETL Processes
The proliferation of business intelligence applications moves most organizations into an era where data becomes an essential part of the success factors. More and more business focus has thus been added to the integration and processing of data in the enterprise environment. Developing and maintaining Extraction-Transform-Load (ETL) processes becomes critical in most data-driven organizations. ...
متن کامل